select join distinct

113

select join distinct -

$items = DB::table('item')->select('item_name')->distinct()->get();

select distinct after join -

SELECT DISTINCT table1.field1, table2.field2 FROM table1
JOIN table2 ON table1.id = table2.id 

Comments

Submit
0 Comments